<?
  /***************************************************************************************************
     PROGRAM DESCRIPTION :  PROGRAM TO VIEW DAILY REPORTS
      VARIABLES          :   click		=total click amnt
   			  				 lead		=total lead amnt
    						 sale		=total sale amnt
    						 subsale	=total subsale amnt
    						 nclick		=total no of clicks
   						     nlead      =total no of leads
   							 nsale      =total no of sales
   							 nsubsale   =total no of subsales
                             programid  =program id
                             Affilaiete =AFFILAIE ID
  //*************************************************************************************************/


  include_once '../includes/constants.php';
  include_once '../includes/functions.php';
  include_once '../includes/session.php';



    $partners=new partners;
    $partners->connection($host,$user,$pass,$db);

    /*****************variables************************************************/
    $AFFILIATEID                     =trim($_SESSION['AFFILIATEID']);
    $programs                        =trim($_POST['programs']);
	

	$d                =$_GET['d'];
	$m                =$_GET['m'];
	$y                =$_GET['y'];
	
	
    /**************************************************************************/



    /************initialisation************************************************/
     if (empty($_SESSION['PROGRAMID']))
  				  $_SESSION['PROGRAMID']='All';
    if (!empty($programs))
   				 $_SESSION['PROGRAMID']=$programs;

    $PROGRAMID                        =$_SESSION['PROGRAMID'];               //setting program id to session
    $sql                              ="SELECT * from partners_joinpgm,partners_program where joinpgm_affiliateid=$AFFILIATEID and joinpgm_status not like ('waiting') and joinpgm_programid=program_id "; //adding to drop down box
    $result2                          =mysql_query($sql);                     //adding     to dropdown box
    /**************************************************************************/



     /*********initalising date totoday ***************************************/
    if (empty($d))
       {
          $today                    =getdate();
          $d                        =$today['mday'];
          $m                        =$today['mon'];   //setting as todays
          $y                        =$today['year'];
       }
    /**************************************************************************/
      $dateoftrans              =$y."-".$m."-".$d;

    /************selected pgms*************************************************/
    switch($PROGRAMID)
    {
    case 'All':
         $sql="SELECT * from partners_joinpgm,partners_program where joinpgm_affiliateid=$AFFILIATEID and  joinpgm_programid=program_id   ";

          # calculate impressions
            $impSql = " SELECT sum(imp_count) AS impr_count FROM partners_impression_daily WHERE imp_affiliateid=$AFFILIATEID ";

            $rawClick = GetRawTrans('click',  0, $AFFILIATEID, 0, 0,  0,0, $dateoftrans)   ;
    		$rawImp   = GetRawTrans('impression', 0, $AFFILIATEID, 0, 0, 0, 0,$dateoftrans)   ;
        break;
     default:
         $sql="SELECT * from partners_joinpgm,partners_program where joinpgm_affiliateid=$AFFILIATEID and  joinpgm_programid=program_id  and  program_id=$PROGRAMID";

          # calculate impressions
            $impSql = " SELECT sum(imp_count) AS impr_count FROM partners_impression_daily WHERE imp_affiliateid=$AFFILIATEID and imp_programid = $PROGRAMID";

            $rawClick = GetRawTrans('click',  0, $AFFILIATEID, $PROGRAMID, 0,  0,0, $dateoftrans)   ;
    		$rawImp   = GetRawTrans('impression', 0, $AFFILIATEID, $PROGRAMID, 0, 0, 0,$dateoftrans)   ;
         break;
     }
      $result1                  =mysql_query($sql);
     /*************************************************************************/




   /************initialisation*************************************************/

	$impression	   			  =0;

    $click                    =0;
    $lead                     =0;
    $sale                     =0;
    $nclick                   =0;
    $nlead                    =0;
    $nsale                    =0;
    $subsale                  =0;
    $nsubsale                 =0;
    /**************************************************************************/

     $impSql   .= " and imp_date = '$dateoftrans'";
     $impRet	= mysql_query($impSql);
	 $row_impr		= mysql_fetch_object($impRet);
	 $numRec		= $row_impr->impr_count;
	 if($numRec == '') $numRec = 0;


   /***********************getting statistics for selected pgms****************/
    while( $rows=mysql_fetch_object($result1))
    {
    	$joinid   =$rows->joinpgm_id; //getting affiliates joined pgms for aprticular merchant
		
		//Added by SMA to find the impression comission amt on 17-JUNE-06
            $sql      ="SELECT * from partners_transaction where transaction_dateoftransaction='$dateoftrans' and transaction_type='impression' and transaction_joinpgmid=$joinid";
            $result   =mysql_query($sql);
            while($row=mysql_fetch_object($result))
            {
				$date		 =   $row->transaction_dateoftransaction;
				$imp_amt	= $row->transaction_amttobepaid;
				$impression = $imp_amt + $impression;

            }
		//End add on 17-JUNE-06
		

	    $sql      ="SELECT * from partners_transaction where transaction_dateoftransaction='$dateoftrans' and transaction_type='click' and transaction_joinpgmid=$joinid";
	    $result   =mysql_query($sql);
	    $nclick   =mysql_num_rows($result)+$nclick;   //no of click
	    while($row=mysql_fetch_object($result))
	    {
				$date		 =   $row->transaction_dateoftransaction;
	    		$click_amt	= $row->transaction_amttobepaid;
				
				$click    = $click_amt + $click;  //click amnt
	    }

	    $sql      ="SELECT * from partners_transaction where transaction_dateoftransaction='$dateoftrans' and transaction_type='lead' and transaction_joinpgmid=$joinid";
	    $result   =mysql_query($sql);
	    $nlead    =mysql_num_rows($result)+$nlead;  //no of lead

	    while($row=mysql_fetch_object($result))
	    {
				$date		 =   $row->transaction_dateoftransaction;
	    		$lead_amt	= $row->transaction_amttobepaid;
	    		
				$lead     = $lead_amt + $lead;  //lead amnt
	    }

	    $sql      ="SELECT *  from partners_transaction where transaction_dateoftransaction='$dateoftrans' and transaction_type='sale' and transaction_joinpgmid=$joinid";
	    $result   =mysql_query($sql);
	    $nsale    =mysql_num_rows($result)+$nsale;  //no of sales
	    while($row=mysql_fetch_object($result))
	    {
	//Modified on 23-JUNE-06 for Recurring Sale Commission by SMA
			 $transactionId	= $row->transaction_id;
			 $recur 	 = 	$row->transaction_recur;
	
			  // If the sale commission is of recurring type
			 if($recur == '1') 
			 {
				$sql_Recur 	= "SELECT * FROM partners_recur WHERE recur_transactionid = '$transactionId' ";
				$res_Recur	= mysql_query($sql_Recur);
				if(mysql_num_rows($res_Recur) > 0)
				{
					$row_recur	= mysql_fetch_object($res_Recur);
					$recurId	= $row_recur->recur_id;
					
					$sql_recurpay	= "SELECT * FROM partners_recurpayments WHERE recurpayments_recurid = '$recurId' ";
					$res_recurpay	= mysql_query($sql_recurpay);
					if(mysql_num_rows($res_recurpay) > 0)
					{
						$row_recurpay 	= mysql_fetch_object($res_recurpay);
						$date		 =   $row_recurpay->recurpayments_date;
						$sale_amt	= $row_recurpay->recurpayments_amount;
						
						$sale 	 = $sale_amt  + $sale; 
					}
				}
			 }
			 else
			 {	 
	// END Modified on 23-JUNE-06
				$date		 =   $row->transaction_dateoftransaction;
	    		$sale_amt	= $row->transaction_amttobepaid;
	
			    $sale    = $sale_amt + $sale;  //sale amnt
			 }
	    }
    }

    $sql      ="SELECT *  from partners_transaction where transaction_flag=1 and  transaction_parentid=$AFFILIATEID and transaction_dateoftransaction='$dateoftrans' ";
    $result   =mysql_query($sql);  
    $nsubsale =mysql_num_rows($result)+$nsubsale; //no of subsale
    while($row=mysql_fetch_object($result))
     {
		//Modified on 23-JUNE-06 for Recurring Sale Commission by SMA
				 $transactionId	= $row->transaction_id;
				 $recur 	 = 	$row->transaction_recur;
		
				  // If the sale commission is of recurring type
				 if($recur == '1') 
				 {
					$sql_Recur 	= "SELECT * FROM partners_recur WHERE recur_transactionid = '$transactionId' ";
					$res_Recur	= mysql_query($sql_Recur);
					if(mysql_num_rows($res_Recur) > 0)
					{
						$row_recur	= mysql_fetch_object($res_Recur);
						$recurId	= $row_recur->recur_id;
						
						$sql_recurpay	= "SELECT * FROM partners_recurpayments WHERE recurpayments_recurid = '$recurId' ";
						$res_recurpay	= mysql_query($sql_recurpay);
						if(mysql_num_rows($res_recurpay) > 0)
						{
							$row_recurpay 	= mysql_fetch_object($res_recurpay);
							
							$date		 =   $row_recurpay->recurpayments_date;
							$subsale_amt	= $row_recurpay->recurpayments_subsaleamount;
							
							$subsale 	 =  $subsale_amt + $subsale; 
						}
					}
				 }
				 else
				 {	 
		// END Modified on 23-JUNE-06
					$date		 =   $row->transaction_dateoftransaction;
					$subsale_amt	= $row->transaction_subsale;
		
					$subsale  = $subsale_amt + $subsale;//total sale amnt
				 } 
     }
    /**************************************************************************/
 ?>
<form name="Getprogram" method="post" action="">
        <br/>
        <table border="0"  cellpadding="0" cellspacing="0"  class="tablebdr1"  align="center" width="80%" >
         <tr>
                      
                      <td align="left" height="25"  class="tdhead" ><?=$lang_home_pgms?>
                      <select name="programs" onchange="document.Getprogram.submit()"><option value="All" ><?=$lang_home_all_pgms?></option>
                               <?  while($row=mysql_fetch_object($result2))

                               {
                               if($PROGRAMID=="$row->program_id")
                                      $programName="selected = 'selected'";
                               else
                                $programName="";

                               ?>
                                 <option <?=$programName?> value="<?=$row->program_id?>"><?=$common_id?>:<?=$row->program_id?>...<?=stripslashes($row->program_url)?> </option>
                               <?
                               }
                               ?>
                           </select>
                           </td>
				<?
			$selDate		= $d.".".$m.".".$y;	
			$values	= $numRec."~".$impression."~".$nclick."~".$click."~".$nlead."~".$lead."~".$nsale."~".$sale."~".$nsubsale."~".$subsale."~".$currSymbol;
				
				?>
				<td width="40%" class="tdhead" align="right">
					<a href="#" onClick="window.open('../print_daily.php?aid=<?=$AFFILIATEID?>&mode=affiliate&date=<?=$selDate?>&values=<?=$values?>&program=<?=$PROGRAMID?>','new','400,400,scrollbars=1,resizable=1');" ><b><?=$lang_print_report_head?></b></a>&nbsp;&nbsp;&nbsp;&nbsp;<a href="../csv_daily.php?aid=<?=$AFFILIATEID?>&mode=affiliate&date=<?=$selDate?>&values=<?=$values?>&program=<?=$PROGRAMID?>"><b><?=$lang_export_csv_head?></b></a>
				</td>
						   
                          
        </tr>
        <tr>
           <td  colspan="2" width="100%" align="center" height="30"  class="red"><b><?=$lang_report?> <? echo "$d.$m.$y" ?></b></td>
        </tr>
		<tr>
			<td colspan="2">
		<table cellpadding="0" cellspacing="0" width="100%">
        <tr>

           <td width="60%" height="100%" valign="top">

              <table width="95%" align="right" cellspacing="1" class="tablebdr" >
               <tr>
                     <td width="40%"  class="tdhead"><?=$lang_home_transaction?></td>
                     <td width="30%"  class="tdhead"><?=$lang_home_number?></td>
                     <td width="30%"  class="tdhead"><?=$lang_home_commission?></td>
               </tr>
               <tr>
                     <td width="25%" class="grid1" height="25"><?=$lang_affiliate_imp?></td>
                     <td width="25%" class="grid1"  height="25"><?=$numRec?></td>
                     <td width="25%" class="grid1"  height="25"><?=$currSymbol?><?=$impression?></td>
                 </tr>
               <tr>
                     <td width="25%" class="grid1" height="25"><?=$lang_affiliate_head_click?>&nbsp;<img
                      alt="" border="0" height="10" src="../images/click.gif"
                     width="10" /></td>
                     <td width="25%" class="grid1"  height="25"><?=$nclick?></td>
                     <td width="25%" class="grid1"  height="25"><?=$currSymbol?><?=$click?></td>
                 </tr>
                 <tr>
                     <td width="25%" class="grid1"  height="25"><?=$lang_affiliate_head_lead?>&nbsp;<img
                     alt="" border="0"   height="10" src="../images/lead.gif"
                     width="10" /></td>
                     <td width="25%" class="grid1" height="25"><?=$nlead?></td>
                     <td width="25%" class="grid1"   height="25"><?=$currSymbol?><?=$lead?></td>
                 </tr>
                 <tr>
                     <td width="25%" class="grid1"  height="25"><?=$lang_affiliate_head_sale?>&nbsp;<img
                      alt="" border="0" height="10" src="../images/sale.gif"
                      width="10" /></td>
                     <td width="25%" class="grid1"  height="25"><?=$nsale?></td>
                     <td width="25%" class="grid1"  height="25"><?=$currSymbol?><?=$sale?></td>
                 </tr>
                  <tr>
                     <td width="25%" class="grid1"  height="25"><?=$lang_affiliate_head_subsale?>&nbsp;</td>
                     <td width="25%" class="grid1"  height="25"><?=$nsubsale?></td>
                     <td width="25%" class="grid1"  height="28"><?=$currSymbol?><?=$subsale?></td>
                 </tr>
               </table><br/> </td>
         <td width="1%" height="100%">
         </td>
		<td width="30%" height="100%" valign='top'>

<?php

include 'calender.php';

$d                =$_GET['d'];
$m                =$_GET['m'];
$y                =$_GET['y'];



//adding calender

class MyCalendar1 extends Calendar
{
    function getCalendarLink($month, $year)
    {
        $s                         = getenv('SCRIPT_NAME');
        $act        =$_GET['Action'];

        $qry                ="?";
        $sep                ="" ;

       foreach($_GET as $k => $v) {
            if($k=="month" or $k=="year") continue;
            $qry.=$sep.$k."=".$v;
                           $sep="&";
                  }
       return "$s$qry&amp;month=$month&amp;year=$year";
    }



    function getDateLink($day, $month, $year)
    {
        // Only link the first day of every month
        $link = "";
        return $link;
    }

}
if ($month == "")
   {
         $month = date("m");
   }
if ($year == "")
   {
       $year = date("Y");
   }

$cal1 = new MyCalendar1($id);
echo $cal1->getMonthView($month, $year);
?>


             </td>
			
    </tr>
	</table>
	</td>
	</tr>
	
	 <tr>
	   <td width="100%"   height="20" colspan="2">
	   	<table cellpadding="0" cellspacing="0" width="50%" align="center">
			<tr>
				<td><? viewRawTrans($rawClick, $rawImp) ?></td>
			</tr>
		</table>
	    </td>
	</tr>
	<tr>
	   <td width="100%" class="tdhead"  height="20" colspan="2">  </td>
	</tr>

</table>
 </form>